﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace DAL
{
    public class ChartDBAccess
    {
        /// <summary>
        /// Get Chart
        /// </summary>
        /// <param name="Year"></param>
        /// <param name="CONNECTION_STRING"></param>
        /// <returns></returns>
        public DataTable GetCardsTableReceived(int Year, String CONNECTION_STRING)
        {
            SqlParameter[] parameters = new SqlParameter[]
            {
                new SqlParameter("@year",Year),
            };
            DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("getDataChart", CommandType.StoredProcedure, CONNECTION_STRING, parameters);
            return table;
        }
    }
}
